referential integrity constraints

Replication to non-DB2 target tables with referential integrity constraints is supported only if you manually define the constraints on the corresponding nicknames.

只有在相应别名上手工定义约束，才支持到带有参照完整性约束的非DB2目标表的复制。

互联网摘选

Copy tables, data, stored procedures, referential integrity constraints, security, and indexes. Specify the object ( s) to copy.

复制表、数据、存储过程、引用完整性约束、安全性和索引。请指定要复制的对象。

互联网摘选

The data volumes in data warehouse databases make traditional referential integrity constraints too costly.

数据仓库中的数据量使得传统引用完整性约束的成本太高。

互联网摘选

Even though referential integrity and check constraints are very helpful during the ETL process to help detect data problems, implementing them on final data warehouse tables is not efficient.

在ETL过程中，即时参照完整性和检查约束极其有助于检测数据问题，在最终的数据仓库表中实现它们也不会高效。

互联网摘选

During such operations, the database also maintains referential integrity constraints.

重用表中的空闲空间，新旧数据交叉存放，维持完整性约束。

互联网摘选

Referential integrity constraints enforce the relational structure of the database.

参照完整性约束可以加强数据库的关系结构。

provided by jukuu

STEP E: Define appropriate referential integrity constraints between the fact table and the three dimension tables.

第5步：在事实表和3个维度表之间建立正确的引用完整性约束。

互联网摘选

Do not include any clauses defining declarative referential integrity constraints.

不要包括可定义声明引用完整性约束的子句。

互联网摘选

Recommendation: Use the "no load" option for nicknames with referential integrity constraints and load the target table outside of the replication administration tools.

推荐：为带有参照完整性约束的别名使用“no load”选项，并在复制管理工具外部装入目标表。

互联网摘选

Also, the Q Apply program does not drop referential integrity constraints on nicknames during the loading process and then restore them.

同样，在执行装入操作期间，Q Apply程序也不删除别名上的参照完整性约束，并在这之后恢复它们。

互联网摘选

This table uses referential integrity constraints to ensure data validity.

这个表使用引用完整性约束确保数据的有效性。

互联网摘选

For tables that use cascading referential integrity constraints, such as the on delete cascade clause and the on update cascade clause, replication now supports merge operations on precomputed partitions.

现在，对于使用级联引用完整性约束（例如，ondeletecascade子句和onupdatecascade子句）的表，复制支持预计算分区上的合并操作。

provided by jukuu

Referential integrity constraints are not replicated, indexes are optionally replicated.

不会复制引用完整性约束，可以选择复制索引。

provided by jukuu